package com.vogue.supplymall.account.domain.mapper;

import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import com.vogue.supplymall.account.domain.model.User;

/**
 * Created by 崔岳 on 2017-12-1.
 */
@Mapper
public interface UserMapper extends BaseMapper<User,Long>{

	@Select("select u.* from base_user u,rel_user_code ruc where u.id=ruc.userid and u.matchid=#{arg0} and ruc.syscodeid=#{arg1}")
	public List<User> getUserByMatchId(String matchId, Long syscodeId);

	@Select("SELECT * from base_user where id = #{arg0} and defsyscodeid = #{arg1}")
	public List<User> getUserById(Long userId, Long syscodeId);
	
}
